Precision Software Appli…tions Silver Collection 1/Precision Software Applications Silver Collection Volume One (PSM) (1993).iso/tutor/ezs241td.exe/CASHFLOW.EZS

Text File | 1991-01-03 | 15KB | 1,491 lines

HDR
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
15
10
10
10
10
DAT
1,1,0A
(TODAY)
3,1,2R
   EXAMPLE CO. INC. 5(FIVE) YEAR CASH FLOW PROJECTION (PRO FORMA)
1,2,2R
COPYRIGHT 1986: ENERCO ASSOCIATES. EXAMPLE CASH FLOW PROJECTION
1,3,2R
 FOR EZ-SPREADSHEET.
3,3,2R
     QTR 1
4,3,2R
     QTR 2
5,3,2R
     QTR 3
6,3,2R
     QTR 4
7,3,2R
     QTR 5
8,3,2R
     QTR 6
9,3,2R
     QTR 7
10,3,2R
     QTR 8
11,3,2R
     QTR 9
12,3,2R
    QTR 10
13,3,2R
    QTR 11
14,3,2R
    QTR 12
15,3,2R
    QTR 13
16,3,2R
   QTR 14
17,3,2R
    QTR 15
18,3,2R
    QTR 16
19,3,2R
    QTR 17
20,3,2R
    QTR 18
21,3,2R
    QTR 19
22,3,2R
    QTR 20
23,3,2R
    TOTALS
1,5,2R
NO. OF UNITS PLACED
3,5,0R
11
4,5,0R
12
5,5,0R
12
6,5,0R
12
7,5,0R
20
8,5,0R
20
9,5,0R
20
10,5,0R
20
11,5,0R
20
12,5,0R
20
13,5,0R
20
14,5,0R
20
15,5,0R
20
16,5,0R
20
17,5,0R
20
18,5,0R
20
19,5,0R
24
20,5,0R
24
21,5,0R
24
22,5,0R
24
1,6,2R
CUMULATIVE UNITS
3,6,0R
(C5)
4,6,0R
(C6+D5)
5,6,0R
(D6+E5)
6,6,0R
(E6+F5)
7,6,0R
(F6+G5)
8,6,0R
(G6+H5)
9,6,0R
(H6+I5)
10,6,0R
(I6+J5)
11,6,0R
(J6+K5)
12,6,0R
(K6+L5)
13,6,0R
(L6+M5
14,6,0R
(M6+N5
15,6,0R
(N6+M5
16,6,0R
(O6+P5
17,6,0R
(P6+Q5
18,6,0R
(Q6+R5)
19,6,0R
(R6+S5
20,6,0R
(S6+T5)
21,6,0R
(T6+U5
22,6,0R
(U6+V5
1,7,2R
ACTUAL UNITS IN LEASE
3,7,0R
(.75*C6)
4,7,0R
(.75*D6)
5,7,0R
(.75*E6)
6,7,0R
(.75*F6)
7,7,0R
(.75*G6)
8,7,0R
(.75*H6)
9,7,0R
(.75*I6)
10,7,0R
(.75*J6)
11,7,0R
(.75*K6)
12,7,0R
(.75*L6)
13,7,0R
(.75*M6-C7)
14,7,0R
(.75*N6-D7)
15,7,0R
(.75*O6-E7)
16,7,0R
(.75*P6-F7)
17,7,0R
(.75*Q6-G7)
18,7,0R
(.75*R6-H7)
19,7,0R
(.75*S6-I7)
20,7,0R
(.75*T6-J7)
21,7,0R
(.75*U6-K7)
22,7,0R
(.75*V6-L7)
1,8,2R
SALES INCOME
3,8,2R
(.25*C5*4000)
4,8,2R
(.25*D5*4000)
5,8,2R
(.25*E5*4000)
6,8,2R
(.25*F5*4000)
7,8,2R
(.25*G5*4000)
8,8,2R
(.25*H5*4000)
9,8,2R
(.25*I5*4000)
10,8,2R
(.25*J5*4000)
11,8,2R
(.25*K5*4000)
12,8,2R
(.25*L5*4000)
13,8,2R
(.25*M5*4000)
14,8,2R
(.25*N5*4000)
15,8,2R
(.25*O5*4000)
16,8,2R
(.25*P5*4000)
17,8,2R
(.25*Q5*4000)
18,8,2R
(.25*R5*4000)
19,8,2R
(.25*S5*4000)
20,8,2R
(.25*T5*4000)
21,8,2R
(.25*U5*4000)
22,8,2R
(.25*V5*4000)
23,8,2D
(C8:V8)
1,9,2R
  25% OF UNITS PLACED
1,10,2R
OTHER INCOME $100 X
3,10,2R
(.1*C6*1000)
4,10,2R
(.1*D6*1000)
5,10,2R
(.1*E6*1000)
6,10,2R
(.1*F6*1000)
7,10,2R
(.1*G6*1000)
8,10,2R
(.1*H6*1000)
9,10,2R
(.1*I6*1000)
10,10,2R
(.1*J6*1000)
11,10,2R
(.1*K6*1000)
12,10,2R
(.1*L6*1000)
13,10,2R
(.1*M6*1000)
14,10,2R
(.1*N6*1000)
15,10,2R
(.1*O6*1000)
16,10,2R
(.1*P6*1000)
17,10,2R
(.1*Q6*1000)
18,10,2R
(.1*R6*1000)
19,10,2R
(.1*S6*1000)
20,10,2R
(.1*T6*1000)
21,10,2R
(.1*U6*1000)
22,10,2R
(.1*V6*1000)
23,10,2D
(C10:V10)
1,11,2R
  NO. OF UNITS PLACED
1,12,2R
LEASE INCOME $600 X
3,12,2R
(C7*600)
4,12,2R
(D7*600)
5,12,2R
(E7*600)
6,12,2R
(F7*600)
7,12,2R
(G7*600)
8,12,2R
(H7*600)
9,12,2R
(I7*600)
10,12,2R
(J7*600)
11,12,2R
(K7*600)
12,12,2R
(L7*600)
13,12,2R
(M7*600)
14,12,2R
(N7*600)
15,12,2R
(O7*600)
16,12,2R
(P7*600)
17,12,2R
(Q7*600)
18,12,2R
(R7*600)
19,12,2R
(S7*600)
20,12,2R
(T7*600)
21,12,2R
(U7*600)
22,12,2R
(V7*600)
23,12,2D
(C12:V12)
1,13,2R
  UNITS IN LEASE
1,14,2R
TOTAL INCOME
3,14,2R
(C8:C12)
4,14,2R
(D8:D12)
5,14,2R
(E8:E12)
6,14,2R
(F8:F12)
7,14,2R
(G8:G12)
8,14,2R
(H8:H12)
9,14,2R
(I8:I12)
10,14,2R
(J8:J12)
11,14,2R
(K8:K12)
12,14,2R
(L8:L12)
13,14,2R
(M8:M12)
14,14,2R
(N8:N12)
15,14,2R
(O8:O12)
16,14,2R
(P8:P12)
17,14,2R
(Q8:Q12)
18,14,2R
(R8:R12)
19,14,2R
(S8:S12)
20,14,2R
(T8:T12)
21,14,2R
(U8:U12)
22,14,2R
(V8:V12)
23,14,2D
(C14:V14)
1,15,2R
ACCOUNTS RECEIVEABLE
3,15,2R
(.75*C5*6000)
4,15,2R
(.75)*6000*(D5+.9*C5)
5,15,2R
(.75)*6000*(E5+.9*D5+.8*C5)
6,15,2R
(.75)*6000*(F5+.9*E5+.8*D5+.7*C5)
7,15,2R
(.75)*6000*(G5+.9*F5+.8*E5+.7*D5+.6*C5)
8,15,2R
(.75)*6000*(H5+.9*G5+.8*F5+.7*E5+.6*D5+.5*C5)
9,15,2R
(.75)*6000*(I5+.9*H5+.8*G5+.7*F5+.6*E5+.5*D5+.4*C5)
10,15,2R
(.75)*6000*(J5+.9*I5+.8*H5+.7*G5+.6*F5+.5*E5+.4*D5+.3*C5)
11,15,2R
(.75)*6000*(K5+.9*J5+.8*I5+.7*H5+.6*G5+.5*F5+.4*E5+.3*D5+.2*C5)
12,15,2R
(.75)*6000*(L5+.9*K5+.8*J5+.7*I5+.6*H5+.5*G5+.4*F5+.3*E5+.2*D5+.1*C5)
13,15,2R
(.75)*6000*(M5+.9*L5+.8*K5+.7*J5+.6*I5+.5*H5+.4*G5+.3*F5+.2*E5+.1*D5)
14,15,2R
(.75)*6000*(N5+.9*M5+.8*L5+.7*K5+.6*J5+.5*I5+.4*H5+.3*G5+.2*F5+.1*E5)
15,15,2R
(.75)*6000*(O5+.9*N5+.8*M5+.7*L5+.6*K5+.5*J5+.4*I5+.3*H5+.2*G5+.1*F5)
16,15,2R
(.75)*6000*(P5+.9*O5+.8*N5+.7*M5+.6*L5+.5*K5+.4*J5+.3*I5+.2*H5+.1*G5)
17,15,2R
(.75)*6000*(Q5+.9*P5+.8*O5+.7*N5+.6*M5+.5*L5+.4*K5+.3*J5+.2*I5+.1*H5)
18,15,2R
(.75)*6000*(R5+.9*Q5+.8*P5+.7*O5+.6*N5+.5*M5+.4*L5+.3*K5+.2*J5+.1*I5)
19,15,2R
(.75)*6000*(S5+.9*R5+.8*Q5+.7*P5+.6*O5+.5*N5+.4*M5+.3*L5+.2*K5+.1*J5)
20,15,2R
(.75)*6000*(T5+.9*S5+.8*R5+.7*Q5+.6*P5+.5*O5+.4*N5+.3*M5+.2*L5+.1*K5)
21,15,2R
(.75)*6000*(U5+.9*T5+.8*S5+.7*R5+.6*Q5+.5*P5+.4*O5+.3*N5+.2*M5+.1*L5)
22,15,2R
(.75)*6000*(V5+.9*U5+.8*T5+.7*S5+.6*R5+.5*Q5+.4*P5+.3*O5+.2*N5+.1*M5)
1,18,2R
EXPENSES
1,19,2R
  ADVERTIZING
3,19,2R
3000
4,19,2R
(C19)
5,19,2R
(D19)
6,19,2R
(E19)
7,19,2R
(F19)
8,19,2R
(G19)
9,19,2R
(H19)
10,19,2R
(I19)
11,19,2R
(J19)
12,19,2R
(K19)
13,19,2R
(L19)
14,19,2R
(M19)
15,19,2R
(N19)
16,19,2R
(O19)
17,19,2R
(P19)
18,19,2R
(Q19)
19,19,2R
(R19)
20,19,2R
(S19)
21,19,2R
(T19)
22,19,2R
(U19)
23,19,2D
(C19:V19)
1,20,2R
  ACCOUNTING
3,20,2R
300
4,20,2R
(C20)
5,20,2R
(D20)
6,20,2R
(E20)
7,20,2R
(F20)
8,20,2R
(G20)
9,20,2R
(H20)
10,20,2R
(I20)
11,20,2R
(J20)
12,20,2R
(K20)
13,20,2R
(L20)
14,20,2R
(M20)
15,20,2R
(N20)
16,20,2R
(O20)
17,20,2R
(P20)
18,20,2R
(Q20)
19,20,2R
(R20)
20,20,2R
(S20)
21,20,2R
(T20)
22,20,2R
(U20)
23,20,2D
(C20:V20)
1,21,2R
  CONSULTING FEES
3,21,2R
500
4,21,2R
(C21)
5,21,2R
(D21)
6,21,2R
(E21)
7,21,2R
(F21)
8,21,2R
(G21)
9,21,2R
(H21)
10,21,2R
(I21)
11,21,2R
(J21)
12,21,2R
(K21)
13,21,2R
(L21)
14,21,2R
(M21)
15,21,2R
(N21)
16,21,2R
(O21)
17,21,2R
(P21)
18,21,2R
(Q21)
19,21,2R
(R21)
20,21,2R
(S21)
21,21,2R
(T21)
22,21,2R
(U21)
23,21,2D
(C21:V21)
1,22,2R
  LEGAL FEES
3,22,2R
500
4,22,2R
(C22)
5,22,2R
(D22)
6,22,2R
(E22)
7,22,2R
(F22)
8,22,2R
(G22)
9,22,2R
(H22)
10,22,2R
(I22)
11,22,2R
(J22)
12,22,2R
(K22)
13,22,2R
(L22)
14,22,2R
(M22)
15,22,2R
(N22)
16,22,2R
(O22)
17,22,2R
(P22)
18,22,2R
(Q22)
19,22,2R
(R22)
20,22,2R
(S22)
21,22,2R
(T22)
22,22,2R
(U22)
23,22,2D
(C22:V22)
1,23,2R
  SALARIES/BENEFITS
3,23,2R
19000
4,23,2R
(C23)
5,23,2R
(D23)
6,23,2R
(E23)
7,23,2R
(F23)
8,23,2R
(G23)
9,23,2R
(H23)
10,23,2R
(I23)
11,23,2R
(J23)
12,23,2R
(K23)
13,23,2R
22000
14,23,2R
(M23)
15,23,2R
(N23)
16,23,2R
(O23)
17,23,2R
(P23)
18,23,2R
(Q23)
19,23,2R
(R23)
20,23,2R
(S23)
21,23,2R
(T23)
22,23,2R
(U23)
23,23,2D
(C23:V23)
1,24,2R
  RENT
3,24,2R
1800
4,24,2R
(C24)
5,24,2R
(D24)
6,24,2R
(E24)
7,24,2R
(F24)
8,24,2R
(G24)
9,24,2R
(H24)
10,24,2R
(I24)
11,24,2R
(J24)
12,24,2R
(K24)
13,24,2R
(L24)
14,24,2R
(M24)
15,24,2R
(N24)
16,24,2R
(O24)
17,24,2R
(P24)
18,24,2R
(Q24)
19,24,2R
(R24)
20,24,2R
(S24)
21,24,2R
(T24)
22,24,2R
(U24)
23,24,2D
(C24:V24)
1,25,2R
  UTILITIES
3,25,2R
900
4,25,2R
(C25)
5,25,2R
(D25)
6,25,2R
(E25)
7,25,2R
(F25)
8,25,2R
(G25)
9,25,2R
(H25)
10,25,2R
(I25)
11,25,2R
(J25)
12,25,2R
(K25)
13,25,2R
(L25)
14,25,2R
(M25)
15,25,2R
(N25)
16,25,2R
(O25)
17,25,2R
(P25)
18,25,2R
(Q25)
19,25,2R
(R25)
20,25,2R
(S25)
21,25,2R
(T25)
22,25,2R
(U25)
23,25,2D
(C25:V25)
1,26,2R
  TELEPHONE
3,26,2R
1000
4,26,2R
(C26)
5,26,2R
(D26)
6,26,2R
(E26)
7,26,2R
(F26)
8,26,2R
(G26)
9,26,2R
(H26)
10,26,2R
(I26)
11,26,2R
(J26)
12,26,2R
(K26)
13,26,2R
(L26)
14,26,2R
(M26)
15,26,2R
(N26)
16,26,2R
(O26)
17,26,2R
(P26)
18,26,2R
(Q26)
19,26,2R
(R26)
20,26,2R
(S26)
21,26,2R
(T26)
22,26,2R
(U26)
23,26,2D
(C26:V26)
1,27,2R
  REPAIRS & MNT.
3,27,2R
600
4,27,2R
(C27)
5,27,2R
(D27)
6,27,2R
(E27)
7,27,2R
(F27)
8,27,2R
(G27)
9,27,2R
(H27)
10,27,2R
(I27)
11,27,2R
(J27)
12,27,2R
(K27)
13,27,2R
(L27)
14,27,2R
(M27)
15,27,2R
(N27)
16,27,2R
(O27)
17,27,2R
(P27)
18,27,2R
(Q27)
19,27,2R
(R27)
20,27,2R
(S27)
21,27,2R
(T27)
22,27,2R
(U27)
23,27,2D
(C27:V27)
1,28,2R
  OTHER EXPENSES
3,28,2R
500
4,28,2R
(C28)
5,28,2R
(D28)
6,28,2R
(E28)
7,28,2R
(F28)
8,28,2R
(G28)
9,28,2R
(H28)
10,28,2R
(I28)
11,28,2R
(J28)
12,28,2R
(K28)
13,28,2R
(L28)
14,28,2R
(M28)
15,28,2R
(N28)
16,28,2R
(O28)
17,28,2R
(P28)
18,28,2R
(Q28)
19,28,2R
(R28)
20,28,2R
(S28)
21,28,2R
(T28)
22,28,2R
(U28)
23,28,2D
(C28:V28)
1,30,2R
 EQUIPMENT/SOFTWARE $
3,30,2R
(C5*2500)
4,30,2R
(D5*2500)
5,30,2R
(E5*2500)
6,30,2R
(F5*2500)
7,30,2R
(G5*2500)
8,30,2R
(H5*2500)
9,30,2R
(I5*2500)
10,30,2R
(J5*2500)
11,30,2R
(K5*2500)
12,30,2R
(L5*2500)
13,30,2R
(M5*2500)
14,30,2R
(N5*2500)
15,30,2R
(O5*2500)
16,30,2R
(P5*2500)
17,30,2R
(Q5*2500)
18,30,2R
(R5*2500)
19,30,2R
(S5*2500)
20,30,2R
(T5*2500)
21,30,2R
(U5*2500)
22,30,2R
(V5*2500)
23,30,2D
(C30:V30)
1,32,2R
TOTAL EXPENSES
3,32,2R
(C19:C30)
4,32,2R
(D19:D30)
5,32,2R
(E19:E30)
6,32,2R
(F19:F30)
7,32,2R
(G19:G30)
8,32,2R
(H19:H30)
9,32,2R
(I19:I30)
10,32,2R
(J19:J30)
11,32,2R
(K19:K30)
12,32,2R
(L19:L30)
13,32,2R
(M19:M30)
14,32,2R
(N19:N30)
15,32,2R
(O19:O30)
16,32,2R
(P19:P30)
17,32,2R
(Q19:Q30)
18,32,2R
(R19:R30)
19,32,2R
(S19:S30)
20,32,2R
(T19:T30)
21,32,2R
(U19:U30)
22,32,2R
(V19:V30)
23,32,2D
(C32:V32)
1,34,2R
 INCOME BEFORE TAXES
3,34,2R
(C14-C32)
4,34,2R
(D14-D32)
5,34,2R
(E14-E32)
6,34,2R
(F14-F32)
7,34,2R
(G14-G32)
8,34,2R
(H14-H32)
9,34,2R
(I14-I32)
10,34,2R
(J14-J32)
11,34,2R
(K14-K32)
12,34,2R
(L14-L32)
13,34,2R
(M14-M32)
14,34,2R
(N14-N32)
15,34,2R
(O14-O32)
16,34,2R
(P14-P32)
17,34,2R
(Q14-Q32)
18,34,2R
(R14-R32)
19,34,2R
(S14-S32)
20,34,2R
(T14-T32)
21,34,2R
(U14-U32)
22,34,2R
(V14-V32)
23,34,2D
(C34:V34)
1,36,2R
ADD:
1,37,2R
  INVESTORS CAPITAL
3,37,2R
100000
4,37,2R
0
5,37,2R
0
6,37,2R
0
7,37,2R
0
8,37,2R
0
9,37,2R
0
10,37,2R
0
11,37,2R
0
12,37,2R
0
13,37,2R
0
14,37,2R
0
15,37,2R
0
16,37,2R
0
17,37,2R
0
18,37,2R
0
19,37,2R
0
20,37,2R
0
21,37,2R
0
22,37,2R
0
23,37,2D
(C37:V37)
1,38,2R
    CONTRIBUTIONS
1,39,2R
  BEGINNING CASH
3,39,2R
0
4,39,2R
(C51)
5,39,2R
(D51)
6,39,2R
(E51)
7,39,2R
(F51)
8,39,2R
(G51)
9,39,2R
(H51)
10,39,2R
(I51)
11,39,2R
(J51)
12,39,2R
(K51)
13,39,2R
(L51)
14,39,2R
(M51)
15,39,2R
(N51)
16,39,2R
(O51)
17,39,2R
(P51)
18,39,2R
(Q51)
19,39,2R
(R51)
20,39,2R
(S51)
21,39,2R
(T51)
22,39,2R
(U51)
1,40,2R
  LOANS
3,40,2R
0
4,40,2R
(IF (C51<=0,-C51,0))
5,40,2R
(IF (D51<=0,-D51,0))
6,40,2R
(IF (E51<=0,-E51,0))
7,40,2R
(IF (F51<=0,-F51,0))
8,40,2R
(IF (G51<=0,-G51,0))
9,40,2R
(IF (H51<=0,-H51,0))
10,40,2R
(IF (I51<=0,-I51,0))
11,40,2R
(IF (J51<=0,-J51,0))
12,40,2R
(IF (K51<=0,-K51,0))
13,40,2R
(IF (L51<=0,-L51,0))
14,40,2R
(IF (M51<=0,-M51,0))
15,40,2R
(IF (N51<=0,-N51,0))
16,40,2R
(IF (O51<=0,-O51,0))
17,40,2R
(IF (P51<=0,-P51,0))
18,40,2R
(IF (Q51<=0,-Q51,0))
19,40,2R
(IF (R51<=0,-R51,0))
20,40,2R
(IF (S51<=0,-S51,0))
21,40,2R
(IF (T51<=0,-T51,0))
22,40,2R
(IF (U51<=0,-U51,0))
1,41,2R
  OUTSTANDING LOANS
3,41,2R
0
4,41,2R
(C41+D40)
5,41,2R
(D41+E40-.5*D48)
6,41,2R
(E41+F40-.5*E48)
7,41,2R
(F41+G40-.5*F48)
8,41,2R
(G41+H40-.5*G48)
9,41,2R
(H41+I40-.5*H48)
10,41,2R
(I41+J40-.5*I48)
11,41,2R
(J41+K40-.5*J48)
12,41,2R
(K41+L40-.5*K48)
13,41,2R
(L41+M40-.5*L48)
14,41,2R
(M41+N40-.5*M48)
15,41,2R
(N41+O40-.5*N48)
16,41,2R
(O41+P40-.5*O48)
17,41,2R
(P41+Q40-.5*P48)
18,41,2R
(Q41+R40-.5*Q48)
19,41,2R
(R41+S40-.5*R48)
20,41,2R
(S41+T40-.5*S48)
21,41,2R
(T41+U40-.5*T48)
22,41,2R
(U41+V40-.5*U48)
23,41,2D
0
1,43,2R
LESS:
1,44,2R
  BOND PURCHASES
3,44,2R
25000
4,44,2R
0
5,44,2R
0
6,44,2R
0
7,44,2R
0
8,44,2R
0
9,44,2R
0
10,44,2R
0
11,44,2R
0
12,44,2R
0
13,44,2R
0
14,44,2R
0
15,44,2R
0
16,44,2R
0
17,44,2R
0
18,44,2R
0
19,44,2R
0
20,44,2R
0
21,44,2R
0
22,44,2R
0
23,44,2D
(C44:V44)
1,45,2R
  LEASE DEPOSITS
3,45,2R
2000
4,45,2R
0
5,45,2R
0
6,45,2R
0
7,45,2R
0
8,45,2R
0
9,45,2R
0
10,45,2R
0
11,45,2R
0
12,45,2R
0
13,45,2R
0
14,45,2R
0
15,45,2R
0
16,45,2R
0
17,45,2R
0
18,45,2R
0
19,45,2R
0
20,45,2R
0
21,45,2R
0
22,45,2R
0
23,45,2D
(C45:V45)
1,46,2R
  WORKING CAPITAL
3,46,2R
2000
4,46,2R
0
5,46,2R
0
6,46,2R
0
7,46,2R
0
8,46,2R
0
9,46,2R
0
10,46,2R
0
11,46,2R
0
12,46,2R
0
13,46,2R
0
14,46,2R
0
15,46,2R
0
16,46,2R
0
17,46,2R
0
18,46,2R
0
19,46,2R
0
20,46,2R
0
21,46,2R
0
22,46,2R
0
23,46,2D
(C46:V46)
1,47,2R
  ORGANIZATION EXP.
3,47,2R
2000
4,47,2R
0
5,47,2R
0
6,47,2R
0
7,47,2R
0
8,47,2R
0
9,47,2R
0
10,47,2R
0
11,47,2R
0
12,47,2R
0
13,47,2R
0
14,47,2R
0
15,47,2R
0
16,47,2R
0
17,47,2R
0
18,47,2R
0
19,47,2R
0
20,47,2R
0
21,47,2R
0
22,47,2R
0
23,47,2D
(C47:V47)
1,48,2R
  LOAN AMORTIZATION
3,48,2R
0
4,48,2R
(.2*D41)
5,48,2R
(.2*D41)
6,48,2R
(.2*E41)
7,48,2R
(.2*F41)
8,48,2R
(.2*G41)
9,48,2R
(.2*H41)
10,48,2R
(.2*I41)
11,48,2R
(.2*J41)
12,48,2R
(.2*K41)
13,48,2R
(.2*L41)
14,48,2R
(.2*M41)
15,48,2R
(.2*N41)
16,48,2R
(.2*O41)
17,48,2R
(.2*P41)
18,48,2R
(.2*Q41)
19,48,2R
(.2*R41)
20,48,2R
(.2*S41)
21,48,2R
(.2*T41)
22,48,2R
(.2*U41)
23,48,2D
(C48:V48)
1,49,2R
  DIVIDENDS
3,49,2R
0
4,49,2R
0
5,49,2R
(IF(D51<=0,0,.5*D51))
6,49,2R
(IF(E51<=0,0,.5*E51))
7,49,2R
(IF(F51<=0,0,.5*F51))
8,49,2R
(IF(G51<=0,0,.5*G51))
9,49,2R
(IF(H51<=0,0,.5*H51))
10,49,2R
(IF(I51<=0,0,.5*I51))
11,49,2R
(IF(J51<=0,0,.5*J51))
12,49,2R
(IF(K51<=0,0,.5*K51))
13,49,2R
(IF(L51<=0,0,.5*L51))
14,49,2R
(IF(M51<=0,0,.5*M51))
15,49,2R
(IF(N51<=0,0,.5*N51))
16,49,2R
(IF(O51<=0,0,.5*O51))
17,49,2R
(IF(P51<=0,0,.5*P51))
18,49,2R
(IF(Q51<=0,0,.5*Q51))
19,49,2R
(IF(R51<=0,0,.5*R51))
20,49,2R
(IF(S51<=0,0,.5*S51))
21,49,2R
(IF(T51<=0,0,.5*T51))
22,49,2R
(IF(U51<=0,0,.5*U51))
23,49,2D
(C49:W49)
1,51,2R
 ENDING CASH BALANCE
3,51,2R
(C34+C37:C40-C44:C49)
4,51,2R
(D34+D37:D40-D44:D49)
5,51,2R
(E34+E37:E40-E44:E49)
6,51,2R
(F34+F37:F40-F44:F49)
7,51,2R
(G34+G37:G40-G44:G49)
8,51,2R
(H34+H37:H40-H44:H49)
9,51,2R
(I34+I37:I40-I44:I49)
10,51,2R
(J34+J37:J40-J44:J49)
11,51,2R
(K34+K37:K40-K44:K49)
12,51,2R
(L34+L37:L40-L44:L49)
13,51,2R
(M34+M37:M40-M44:M49)
14,51,2R
(N34+N37:N40-N44:N49)
15,51,2R
(O34+O37:O40-O44:O49)
16,51,2R
(P34+P37:P40-P44:P49)
17,51,2R
(Q34+Q37:Q40-Q44:Q49)
18,51,2R
(R34+R37:R40-R44:R49)
19,51,2R
(S34+S37:S40-S44:S49)
20,51,2R
(T34+T37:T40-T44:T49)
21,51,2R
(U34+U37:U40-U44:U49)
22,51,2R
(V34+V37:V40-V44:V49)
23,51,2D
(V51-V41)
END